<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `kang_category`;");
E_C("CREATE TABLE `kang_category` (
  `cat_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_name` varchar(90) NOT NULL default '',
  `keywords` varchar(255) NOT NULL default '',
  `cat_desc` varchar(255) NOT NULL default '',
  `parent_id` smallint(5) unsigned NOT NULL default '0',
  `sort_order` tinyint(1) unsigned NOT NULL default '50',
  `template_file` varchar(50) NOT NULL default '',
  `measure_unit` varchar(15) NOT NULL default '',
  `show_in_nav` tinyint(1) NOT NULL default '0',
  `style` varchar(150) NOT NULL,
  `is_show` tinyint(1) unsigned NOT NULL default '1',
  `grade` tinyint(4) NOT NULL default '0',
  `filter_attr` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8");
E_D("replace into `kang_category` values('1','精品红枣','','','6','50','','','0','','1','5','172,185,178');");
E_D("replace into `kang_category` values('2','野生蘑菇','','','6','50','','','0','','1','0','6');");
E_D("replace into `kang_category` values('3','美味干货','','','6','50','','台','0','','1','4','185,189,173,178');");
E_D("replace into `kang_category` values('4','养生菌','','','6','50','','','0','','1','0','28');");
E_D("replace into `kang_category` values('5','健康粗粮','','','6','50','','','0','','1','5','18');");
E_D("replace into `kang_category` values('6','农副产品','','','0','50','','','1','','1','0','');");
E_D("replace into `kang_category` values('7','有机杂粮','','','6','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('8','散装水果','','','12','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('9','新鲜蔬菜','','','6','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('11','柴鸡蛋','','','6','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('12','新鲜水果','','','0','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('13','优质进口','','','12','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('14','新鲜进口','','','12','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('15','本地新鲜','','','12','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('16','肉制品','','','0','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('17','牛肉类','','','16','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('18','食用油','','','0','51','','','0','','1','0','');");
E_D("replace into `kang_category` values('19','农家自产','','','18','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('20','海产类','','','0','50','','','0','','1','0','');");
E_D("replace into `kang_category` values('21','海产干货','','','20','50','','','0','','1','0','');");

require("../../inc/footer.php");
?>